<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>gluon.yapo_builder</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        <a href="gluon-module.html">Package&nbsp;gluon</a> ::
        Module&nbsp;yapo_builder
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="gluon.yapo_builder-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="gluon.yapo_builder-module.html">Module gluon.yapo_builder</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">re</tt><tt class="py-op">,</tt> <tt class="py-name">os</tt><tt class="py-op">,</tt> <tt class="py-name">sys</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-0" class="py-name" targets="Module gluon.yapo=gluon.yapo-module.html"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-0', 'yapo', 'link-0');">yapo</a></tt> <tt class="py-keyword">import</tt> <tt id="link-1" class="py-name" targets="Class gluon.yapo.Yapo=gluon.yapo.Yapo-class.html"><a title="gluon.yapo.Yapo" class="py-name" href="#" onclick="return doclink('link-1', 'Yapo', 'link-1');">Yapo</a></tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"> </tt>
<a name="parse_field"></a><div id="parse_field-def"><a name="L4"></a><tt class="py-lineno">  4</tt> <a class="py-toggle" href="#" id="parse_field-toggle" onclick="return toggle('parse_field');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="gluon.yapo_builder-module.html#parse_field">parse_field</a><tt class="py-op">(</tt><tt class="py-param">f</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="parse_field-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="parse_field-expanded"><a name="L5"></a><tt class="py-lineno">  5</tt>  <tt class="py-line">    <tt class="py-name">re</tt><tt class="py-op">.</tt><tt class="py-name">compile</tt><tt class="py-op">(</tt><tt class="py-string">'(\w*)'</tt><tt class="py-op">)</tt> </tt>
<a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line">    <tt class="py-name">fields</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-string">'string'</tt><tt class="py-op">,</tt><tt class="py-string">'integer'</tt><tt class="py-op">,</tt><tt class="py-string">'text'</tt><tt class="py-op">,</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line">            <tt class="py-string">'double'</tt><tt class="py-op">,</tt><tt class="py-string">'boolean'</tt><tt class="py-op">,</tt><tt class="py-string">'upload'</tt><tt class="py-op">,</tt> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line">            <tt class="py-string">'date'</tt><tt class="py-op">,</tt><tt class="py-string">'datetime'</tt><tt class="py-op">,</tt><tt class="py-string">'time'</tt><tt class="py-op">]</tt> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line">    <tt class="py-keyword">class</tt> <tt class="py-def-name">dummy</tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt class="py-keyword">pass</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line">    <tt class="py-name">a</tt><tt class="py-op">=</tt><tt class="py-name">dummy</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line">    <tt class="py-name">f2</tt><tt class="py-op">,</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">,</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">unique</tt><tt class="py-op">,</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">notnull</tt><tt class="py-op">,</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">private</tt><tt class="py-op">,</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">nocolumn</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-op">]</tt><tt class="py-op">,</tt><tt class="py-string">'string'</tt><tt class="py-op">,</tt><tt class="py-name">False</tt><tt class="py-op">,</tt><tt class="py-name">False</tt><tt class="py-op">,</tt><tt class="py-name">False</tt><tt class="py-op">,</tt><tt class="py-name">False</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt>  <tt class="py-line">    <tt class="py-keyword">for</tt> <tt class="py-name">x</tt> <tt class="py-keyword">in</tt> <tt id="link-2" class="py-name" targets="Variable gluon.wsgiserver.SSLConnection.f=gluon.wsgiserver.SSLConnection-class.html#f"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-2', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt>  </tt>
<a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">x</tt> <tt class="py-keyword">in</tt> <tt class="py-name">fields</tt><tt class="py-op">:</tt> <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">=</tt><tt class="py-name">x</tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">x</tt><tt class="py-op">==</tt><tt class="py-string">'unique'</tt><tt class="py-op">:</tt> <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">unique</tt><tt class="py-op">=</tt><tt class="py-name">True</tt> </tt>
<a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">x</tt><tt class="py-op">==</tt><tt class="py-string">'notnull'</tt><tt class="py-op">:</tt> <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">notnull</tt><tt class="py-op">=</tt><tt class="py-name">True</tt> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">x</tt><tt class="py-op">==</tt><tt class="py-string">'private'</tt><tt class="py-op">:</tt> <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">private</tt><tt class="py-op">=</tt><tt class="py-name">True</tt> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">x</tt><tt class="py-op">==</tt><tt class="py-string">'nocolumn'</tt><tt class="py-op">:</tt> <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">nocolumn</tt><tt class="py-op">=</tt><tt class="py-name">True</tt> </tt>
<a name="L18"></a><tt class="py-lineno"> 18</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt class="py-name">f2</tt><tt class="py-op">.</tt><tt id="link-3" class="py-name" targets="Method gluon.html.DIV.append()=gluon.html.DIV-class.html#append,Method gluon.yapo.Yapo.append()=gluon.yapo.Yapo-class.html#append"><a title="gluon.html.DIV.append
gluon.yapo.Yapo.append" class="py-name" href="#" onclick="return doclink('link-3', 'append', 'link-3');">append</a></tt><tt class="py-op">(</tt><tt class="py-name">x</tt><tt class="py-op">)</tt>  </tt>
<a name="L19"></a><tt class="py-lineno"> 19</tt>  <tt class="py-line">    <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-string">'_'</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">f2</tt><tt class="py-op">)</tt> </tt>
<a name="L20"></a><tt class="py-lineno"> 20</tt>  <tt class="py-line">    <tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">label</tt><tt class="py-op">=</tt><tt class="py-name">a</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">.</tt><tt id="link-4" class="py-name" targets="Function gluon.template.replace()=gluon.template-module.html#replace"><a title="gluon.template.replace" class="py-name" href="#" onclick="return doclink('link-4', 'replace', 'link-4');">replace</a></tt><tt class="py-op">(</tt><tt class="py-string">'_'</tt><tt class="py-op">,</tt><tt class="py-string">' '</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">capitalize</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">a</tt> </tt>
</div><a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line"> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line"><tt id="link-5" class="py-name" targets="Variable gluon.yapo_builder.CRUD=gluon.yapo_builder-module.html#CRUD"><a title="gluon.yapo_builder.CRUD" class="py-name" href="#" onclick="return doclink('link-5', 'CRUD', 'link-5');">CRUD</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L25"></a><tt class="py-lineno"> 25</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line"><tt class="py-string">def list(table):</tt> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt>  <tt class="py-line"><tt class="py-string">   a=request.vars.start or 0</tt> </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line"><tt class="py-string">   b=request.vars.stop or a+25</tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line"><tt class="py-string">   orderby=request.vars.orderby or db[table].fields[0] ### UNSAFE FIX</tt> </tt>
<a name="L30"></a><tt class="py-lineno"> 30</tt>  <tt class="py-line"><tt class="py-string">   items=db(db[table].id&gt;0).select(orderby=orderby,limitby=(a,b+1))</tt> </tt>
<a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line"><tt class="py-string">   return response.render('crud/list_%s.html'%table,items=items)</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line"><tt class="py-string">def create(table,target=None):</tt> </tt>
<a name="L34"></a><tt class="py-lineno"> 34</tt>  <tt class="py-line"><tt class="py-string">   form=SQLFORM(db[table],</tt> </tt>
<a name="L35"></a><tt class="py-lineno"> 35</tt>  <tt class="py-line"><tt class="py-string">                fields=db[table].exposed,</tt> </tt>
<a name="L36"></a><tt class="py-lineno"> 36</tt>  <tt class="py-line"><tt class="py-string">                labels=db[table].labels,</tt> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line"><tt class="py-string">                upload=URL(r=request,f='download'))</tt> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt>  <tt class="py-line"><tt class="py-string">   if form.accepts(request.vars,session):</tt> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T("new record inserted")</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L42"></a><tt class="py-lineno"> 42</tt>  <tt class="py-line"><tt class="py-string">   return response.render('crud/create_%s.html'%table,form=form)</tt> </tt>
<a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt>  <tt class="py-line"><tt class="py-string">def read(table,id,target=None):</tt> </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line"><tt class="py-string">   rows=db(db[table].id==id).select()</tt> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line"><tt class="py-string">   if not len(rows):</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T('record not found')</tt> </tt>
<a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line"><tt class="py-string">   return response.render('crud/read_%s.html'%table,item=rows[0])</tt> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line"><tt class="py-string">def edit(table,id,target=None):</tt> </tt>
<a name="L53"></a><tt class="py-lineno"> 53</tt>  <tt class="py-line"><tt class="py-string">   rows=db(db[table].id==id).select()</tt> </tt>
<a name="L54"></a><tt class="py-lineno"> 54</tt>  <tt class="py-line"><tt class="py-string">   if not len(rows):</tt> </tt>
<a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T('record not found')</tt> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line"><tt class="py-string">   form=SQLFORM(db[table],rows[0],</tt> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt>  <tt class="py-line"><tt class="py-string">                fields=db[table].exposed,</tt> </tt>
<a name="L60"></a><tt class="py-lineno"> 60</tt>  <tt class="py-line"><tt class="py-string">                labels=db[table].labels,</tt> </tt>
<a name="L61"></a><tt class="py-lineno"> 61</tt>  <tt class="py-line"><tt class="py-string">                upload=URL(r=request,f='download'),</tt> </tt>
<a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line"><tt class="py-string">                showid=False,deletable=True)</tt> </tt>
<a name="L63"></a><tt class="py-lineno"> 63</tt>  <tt class="py-line"><tt class="py-string">   if form.accepts(request.vars,session):</tt> </tt>
<a name="L64"></a><tt class="py-lineno"> 64</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T("new record updated")</tt> </tt>
<a name="L65"></a><tt class="py-lineno"> 65</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line"><tt class="py-string">   return response.render('crud/edit_%s.html'%table,form=form)</tt> </tt>
<a name="L68"></a><tt class="py-lineno"> 68</tt>  <tt class="py-line"><tt class="py-string"></tt> </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt>  <tt class="py-line"><tt class="py-string">def delete(table,id,target=None):</tt> </tt>
<a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line"><tt class="py-string">   rows=db(db[table].id==id).select()</tt> </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt>  <tt class="py-line"><tt class="py-string">   if not len(rows):</tt> </tt>
<a name="L72"></a><tt class="py-lineno"> 72</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T('record not found')</tt> </tt>
<a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L75"></a><tt class="py-lineno"> 75</tt>  <tt class="py-line"><tt class="py-string">   if request.vars.confirm=='yes':</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line"><tt class="py-string">       db(query=db[table].id==id).delete()</tt> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line"><tt class="py-string">       session.flash=T('record deleted')</tt> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt>  <tt class="py-line"><tt class="py-string">   elif request.vars.confirm=='no':</tt> </tt>
<a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line"><tt class="py-string">       if target: redirect(target)</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line"><tt class="py-string">       else: redirect(URL(r=request,f='list_'+table))</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt>  <tt class="py-line"><tt class="py-string">   return response.render('crud/delete_%s.html'%table,item=rows[0])</tt> </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line"> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt>  <tt class="py-line"> </tt>
<a name="build_model"></a><div id="build_model-def"><a name="L87"></a><tt class="py-lineno"> 87</tt> <a class="py-toggle" href="#" id="build_model-toggle" onclick="return toggle('build_model');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="gluon.yapo_builder-module.html#build_model">build_model</a><tt class="py-op">(</tt><tt class="py-param">yapo</tt><tt class="py-op">,</tt><tt class="py-param">path</tt><tt class="py-op">=</tt><tt class="py-string">'./'</tt><tt class="py-op">,</tt><tt class="py-param">dbname</tt><tt class="py-op">=</tt><tt class="py-string">'db'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="build_model-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="build_model-expanded"><a name="L88"></a><tt class="py-lineno"> 88</tt>  <tt class="py-line">    <tt class="py-name">path2</tt><tt class="py-op">=</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'models'</tt><tt class="py-op">,</tt><tt class="py-string">'db_crud.py'</tt><tt class="py-op">)</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">    <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">path2</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-6" class="py-name" targets="Method gluon.globals.Response.write()=gluon.globals.Response-class.html#write,Method gluon.widget.IO.write()=gluon.widget.IO-class.html#write,Method gluon.wsgiserver.HTTPRequest.write()=gluon.wsgiserver.HTTPRequest-class.html#write,Method gluon.wsgiserver.SSLConnection.write()=gluon.wsgiserver.SSLConnection-class.html#write,Method gluon.wsgiserver.SSL_fileobject.write()=gluon.wsgiserver.SSL_fileobject-class.html#write"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-6', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-7" class="py-name"><a title="gluon.yapo_builder.CRUD" class="py-name" href="#" onclick="return doclink('link-7', 'CRUD', 'link-5');">CRUD</a></tt><tt class="py-op">)</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt>  <tt class="py-line">        <tt class="py-name">db</tt><tt class="py-op">=</tt><tt id="link-8" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-8', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">model</tt> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">=</tt><tt class="py-string">"import datetime\n"</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"now_date=datetime.date.today()\n"</tt> </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"now_datetime=datetime.datetime.today()\n"</tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"now_time=now_datetime.strftime('%H:%M:%S')\n\n"</tt> </tt>
<a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"db=SQLDB('%s')\n\n"</tt> <tt class="py-op">%</tt> <tt id="link-9" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-9', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">uri</tt> </tt>
<a name="L97"></a><tt class="py-lineno"> 97</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">t</tt> <tt class="py-keyword">in</tt> <tt class="py-name">db</tt><tt class="py-op">.</tt><tt id="link-10" class="py-name" targets="Method gluon.yapo.Yapo.keys()=gluon.yapo.Yapo-class.html#keys"><a title="gluon.yapo.Yapo.keys" class="py-name" href="#" onclick="return doclink('link-10', 'keys', 'link-10');">keys</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L98"></a><tt class="py-lineno"> 98</tt>  <tt class="py-line">            <tt class="py-name">exposed</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line">            <tt class="py-name">labels</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line">            <tt class="py-name">columns</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L101"></a><tt class="py-lineno">101</tt>  <tt class="py-line">            <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"db.define_table('table_%s',\n"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L102"></a><tt class="py-lineno">102</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt id="link-11" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-11', 'f', 'link-2');">f</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">db</tt><tt class="py-op">[</tt><tt class="py-name">t</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt id="link-12" class="py-name" targets="Method gluon.yapo.Yapo.values()=gluon.yapo.Yapo-class.html#values"><a title="gluon.yapo.Yapo.values" class="py-name" href="#" onclick="return doclink('link-12', 'values', 'link-12');">values</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line">                <tt id="link-13" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-13', 'f', 'link-2');">f</a></tt><tt class="py-op">=</tt><tt id="link-14" class="py-name" targets="Function gluon.yapo_builder.parse_field()=gluon.yapo_builder-module.html#parse_field"><a title="gluon.yapo_builder.parse_field" class="py-name" href="#" onclick="return doclink('link-14', 'parse_field', 'link-14');">parse_field</a></tt><tt class="py-op">(</tt><tt id="link-15" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-15', 'f', 'link-2');">f</a></tt><tt class="py-op">)</tt> </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt id="link-16" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-16', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt> <tt class="py-keyword">in</tt> <tt id="link-17" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-17', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">model</tt><tt class="py-op">.</tt><tt id="link-18" class="py-name"><a title="gluon.yapo.Yapo.keys" class="py-name" href="#" onclick="return doclink('link-18', 'keys', 'link-10');">keys</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt id="link-19" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-19', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">=</tt><tt class="py-string">'reference table_'</tt><tt class="py-op">+</tt><tt id="link-20" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-20', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line">                <tt class="py-name">s</tt><tt class="py-op">=</tt><tt class="py-string">"    SQLField('field_%s','%s'"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt id="link-21" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-21', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt><tt id="link-22" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-22', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">)</tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt id="link-23" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-23', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'string'</tt><tt class="py-op">:</tt> </tt>
<a name="L107"></a><tt class="py-lineno">107</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">',length=128'</tt> </tt>
<a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt id="link-24" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-24', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt class="py-number">9</tt><tt class="py-op">]</tt><tt class="py-op">==</tt><tt class="py-string">'reference'</tt><tt class="py-op">:</tt>             </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",\n         requires=IS_IN_DB(db,'table_%s.id','%%(field_%s)s')"</tt><tt class="py-op">%</tt> <tt class="py-op">(</tt><tt id="link-25" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-25', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt><tt id="link-26" class="py-name"><a title="gluon.yapo_builder.parse_field" class="py-name" href="#" onclick="return doclink('link-26', 'parse_field', 'link-14');">parse_field</a></tt><tt class="py-op">(</tt><tt id="link-27" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-27', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">model</tt><tt class="py-op">[</tt><tt id="link-28" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-28', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-29" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-29', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">unique</tt><tt class="py-op">:</tt> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",\n         requires=[IS_NOT_EMPTY(T('cannot be empty')),IS_NOT_IN_DB(db,'table_%s.field_%s')]"</tt><tt class="py-op">%</tt><tt class="py-op">(</tt><tt id="link-30" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-30', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt><tt id="link-31" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-31', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-32" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-32', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">notnull</tt> <tt class="py-keyword">and</tt> <tt id="link-33" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-33', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt> <tt class="py-keyword">in</tt> <tt class="py-op">[</tt><tt class="py-string">'text'</tt><tt class="py-op">,</tt><tt class="py-string">'string'</tt><tt class="py-op">,</tt><tt class="py-string">'integer'</tt><tt class="py-op">,</tt><tt class="py-string">'double'</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">',\n      requires=IS_NOT_EMPTY(T("cannot be empty"))'</tt>  </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt id="link-34" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-34', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'date'</tt><tt class="py-op">:</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",default=now_date"</tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-35" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-35', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'datetime'</tt><tt class="py-op">:</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",default=now_datetime"</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-36" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-36', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'time'</tt><tt class="py-op">:</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",default=now_time"</tt> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-37" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-37', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'integer'</tt><tt class="py-op">:</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",default=0"</tt> </tt>
<a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt id="link-38" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-38', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">field_type</tt><tt class="py-op">==</tt><tt class="py-string">'double'</tt><tt class="py-op">:</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line">                    <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">",default=0.0"</tt> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt>  <tt class="py-line">                <tt class="py-name">s</tt><tt class="py-op">+=</tt><tt class="py-string">'),\n'</tt> </tt>
<a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt id="link-39" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-39', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">private</tt><tt class="py-op">:</tt> <tt class="py-name">exposed</tt><tt class="py-op">.</tt><tt id="link-40" class="py-name"><a title="gluon.html.DIV.append
gluon.yapo.Yapo.append" class="py-name" href="#" onclick="return doclink('link-40', 'append', 'link-3');">append</a></tt><tt class="py-op">(</tt><tt class="py-string">'field_'</tt><tt class="py-op">+</tt><tt id="link-41" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-41', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt>  <tt class="py-line">                <tt class="py-name">labels</tt><tt class="py-op">.</tt><tt id="link-42" class="py-name"><a title="gluon.html.DIV.append
gluon.yapo.Yapo.append" class="py-name" href="#" onclick="return doclink('link-42', 'append', 'link-3');">append</a></tt><tt class="py-op">(</tt><tt class="py-string">"'field_%s':T('%s')"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt id="link-43" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-43', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt><tt id="link-44" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-44', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">label</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L127"></a><tt class="py-lineno">127</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt id="link-45" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-45', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">nocolumn</tt><tt class="py-op">:</tt> <tt class="py-name">columns</tt><tt class="py-op">.</tt><tt id="link-46" class="py-name"><a title="gluon.html.DIV.append
gluon.yapo.Yapo.append" class="py-name" href="#" onclick="return doclink('link-46', 'append', 'link-3');">append</a></tt><tt class="py-op">(</tt><tt class="py-string">'field_'</tt><tt class="py-op">+</tt><tt id="link-47" class="py-name"><a title="gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-47', 'f', 'link-2');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L128"></a><tt class="py-lineno">128</tt>  <tt class="py-line">                <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-name">s</tt> </tt>
<a name="L129"></a><tt class="py-lineno">129</tt>  <tt class="py-line">            <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"    migrate='%s.table')\n\n"</tt> <tt class="py-op">%</tt> <tt class="py-name">t</tt> </tt>
<a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line">            <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"db.table_%s.exposed=%s\n"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">t</tt><tt class="py-op">,</tt><tt class="py-name">repr</tt><tt class="py-op">(</tt><tt class="py-name">exposed</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line">            <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"db.table_%s.columns=%s\n"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">t</tt><tt class="py-op">,</tt><tt class="py-name">repr</tt><tt class="py-op">(</tt><tt class="py-name">columns</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line">            <tt class="py-name">text</tt><tt class="py-op">+=</tt><tt class="py-string">"db.table_%s.labels={%s}\n\n"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">t</tt><tt class="py-op">,</tt><tt class="py-string">', '</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">labels</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">exists</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'models'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line">            <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">mkdir</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'models'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line">        <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'models'</tt><tt class="py-op">,</tt><tt class="py-name">dbname</tt><tt class="py-op">+</tt><tt class="py-string">'.py'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-48" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-48', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt class="py-name">text</tt><tt class="py-op">)</tt> </tt>
</div><a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line"> </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line"><tt id="link-49" class="py-name" targets="Variable gluon.yapo_builder.MAIN_LIST_VIEW=gluon.yapo_builder-module.html#MAIN_LIST_VIEW"><a title="gluon.yapo_builder.MAIN_LIST_VIEW" class="py-name" href="#" onclick="return doclink('link-49', 'MAIN_LIST_VIEW', 'link-49');">MAIN_LIST_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""{{extend 'layout.html'}}{{=XML(list('table_%(name)s'))}}"""</tt> </tt>
<a name="L138"></a><tt class="py-lineno">138</tt>  <tt class="py-line"> </tt>
<a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line"><tt id="link-50" class="py-name" targets="Variable gluon.yapo_builder.CRUD_LIST_VIEW=gluon.yapo_builder-module.html#CRUD_LIST_VIEW"><a title="gluon.yapo_builder.CRUD_LIST_VIEW" class="py-name" href="#" onclick="return doclink('link-50', 'CRUD_LIST_VIEW', 'link-50');">CRUD_LIST_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line"><tt class="py-string">&lt;h1&gt;Table %(name)s&lt;/h1&gt;</tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt>  <tt class="py-line"><tt class="py-string">[{{=A('create new %(name)s',_href=URL(r=request,f='create_table_%(name)s'))}}]</tt> </tt>
<a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line"><tt class="py-string">[[[ add pagination ]]]</tt> </tt>
<a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line"><tt class="py-string">{{if not len(items):}}</tt> </tt>
<a name="L144"></a><tt class="py-lineno">144</tt>  <tt class="py-line"><tt class="py-string">&lt;h2&gt;No %(name)s in database yet&lt;/h2&gt;</tt> </tt>
<a name="L145"></a><tt class="py-lineno">145</tt>  <tt class="py-line"><tt class="py-string">{{else:}}</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line"><tt class="py-string">&lt;h2&gt;%(name)ss in database&lt;/h2&gt;</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line"><tt class="py-string">&lt;table&gt;</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line"><tt class="py-string">   &lt;tr&gt;</tt> </tt>
<a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line"><tt class="py-string">     &lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;id&lt;/b&gt;&lt;/td&gt;</tt> </tt>
<a name="L150"></a><tt class="py-lineno">150</tt>  <tt class="py-line"><tt class="py-string">     {{for field in db.table_%(name)s.columns:}}</tt> </tt>
<a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line"><tt class="py-string">          &lt;td&gt;&lt;b&gt;{{=db.table_%(name)s.labels[field]}}&lt;/b&gt;&lt;/td&gt;</tt> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line"><tt class="py-string">     {{pass}}</tt> </tt>
<a name="L153"></a><tt class="py-lineno">153</tt>  <tt class="py-line"><tt class="py-string">     &lt;td&gt;&lt;/td&gt;</tt> </tt>
<a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line"><tt class="py-string">   &lt;/tr&gt;</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line"><tt class="py-string">{{for i,item in enumerate(items):}}</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line"><tt class="py-string">   {{if i==25: break}}</tt> </tt>
<a name="L157"></a><tt class="py-lineno">157</tt>  <tt class="py-line"><tt class="py-string">   &lt;tr&gt;</tt> </tt>
<a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line"><tt class="py-string">     &lt;td&gt;&lt;input type="checkbox" name="{{='table_%(name)s_record_'+str(item.id)}}" /&gt;</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line"><tt class="py-string">     &lt;td&gt;[{{=item.id}}]&lt;/td&gt;</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt>  <tt class="py-line"><tt class="py-string">     {{for field in db.table_%(name)s.columns:}}</tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line"><tt class="py-string">          &lt;td&gt;{{=item[field]}}&lt;/td&gt;</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line"><tt class="py-string">     {{pass}}</tt> </tt>
<a name="L163"></a><tt class="py-lineno">163</tt>  <tt class="py-line"><tt class="py-string">     &lt;td&gt;[{{=A('read',_href=URL(r=request,f='read_table_%(name)s',args=[item.id]))}}]</tt> </tt>
<a name="L164"></a><tt class="py-lineno">164</tt>  <tt class="py-line"><tt class="py-string">[{{=A('edit',_href=URL(r=request,f='edit_table_%(name)s',args=[item.id]))}}]</tt> </tt>
<a name="L165"></a><tt class="py-lineno">165</tt>  <tt class="py-line"><tt class="py-string">[{{=A('delete',_href=URL(r=request,f='delete_table_%(name)s',args=[item.id]))}}]&lt;/td&gt;</tt> </tt>
<a name="L166"></a><tt class="py-lineno">166</tt>  <tt class="py-line"><tt class="py-string">   &lt;/tr&gt;</tt> </tt>
<a name="L167"></a><tt class="py-lineno">167</tt>  <tt class="py-line"><tt class="py-string">{{pass}}</tt> </tt>
<a name="L168"></a><tt class="py-lineno">168</tt>  <tt class="py-line"><tt class="py-string">&lt;/table&gt;</tt> </tt>
<a name="L169"></a><tt class="py-lineno">169</tt>  <tt class="py-line"><tt class="py-string">{{pass}}</tt> </tt>
<a name="L170"></a><tt class="py-lineno">170</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L171"></a><tt class="py-lineno">171</tt>  <tt class="py-line"> </tt>
<a name="L172"></a><tt class="py-lineno">172</tt>  <tt class="py-line"><tt id="link-51" class="py-name" targets="Variable gluon.yapo_builder.MAIN_CREATE_VIEW=gluon.yapo_builder-module.html#MAIN_CREATE_VIEW"><a title="gluon.yapo_builder.MAIN_CREATE_VIEW" class="py-name" href="#" onclick="return doclink('link-51', 'MAIN_CREATE_VIEW', 'link-51');">MAIN_CREATE_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""{{extend 'layout.html'}}{{=XML(create('table_%(name)s'))}}"""</tt> </tt>
<a name="L173"></a><tt class="py-lineno">173</tt>  <tt class="py-line"> </tt>
<a name="L174"></a><tt class="py-lineno">174</tt>  <tt class="py-line"><tt id="link-52" class="py-name" targets="Variable gluon.yapo_builder.CRUD_CREATE_VIEW=gluon.yapo_builder-module.html#CRUD_CREATE_VIEW"><a title="gluon.yapo_builder.CRUD_CREATE_VIEW" class="py-name" href="#" onclick="return doclink('link-52', 'CRUD_CREATE_VIEW', 'link-52');">CRUD_CREATE_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L175"></a><tt class="py-lineno">175</tt>  <tt class="py-line"><tt class="py-string">&lt;h1&gt;Create new %(name)s&lt;/h1&gt;</tt> </tt>
<a name="L176"></a><tt class="py-lineno">176</tt>  <tt class="py-line"><tt class="py-string">{{=form}}</tt> </tt>
<a name="L177"></a><tt class="py-lineno">177</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L178"></a><tt class="py-lineno">178</tt>  <tt class="py-line"> </tt>
<a name="L179"></a><tt class="py-lineno">179</tt>  <tt class="py-line"><tt id="link-53" class="py-name" targets="Variable gluon.yapo_builder.MAIN_READ_VIEW=gluon.yapo_builder-module.html#MAIN_READ_VIEW"><a title="gluon.yapo_builder.MAIN_READ_VIEW" class="py-name" href="#" onclick="return doclink('link-53', 'MAIN_READ_VIEW', 'link-53');">MAIN_READ_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""{{extend 'layout.html'}}{{=XML(read('table_%(name)s',request.args[0]))}}"""</tt> </tt>
<a name="L180"></a><tt class="py-lineno">180</tt>  <tt class="py-line"> </tt>
<a name="L181"></a><tt class="py-lineno">181</tt>  <tt class="py-line"><tt id="link-54" class="py-name" targets="Variable gluon.yapo_builder.CRUD_READ_VIEW=gluon.yapo_builder-module.html#CRUD_READ_VIEW"><a title="gluon.yapo_builder.CRUD_READ_VIEW" class="py-name" href="#" onclick="return doclink('link-54', 'CRUD_READ_VIEW', 'link-54');">CRUD_READ_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L182"></a><tt class="py-lineno">182</tt>  <tt class="py-line"><tt class="py-string">&lt;h1&gt;Read %(name)s&lt;/h1&gt;</tt> </tt>
<a name="L183"></a><tt class="py-lineno">183</tt>  <tt class="py-line"><tt class="py-string">&lt;table&gt;</tt> </tt>
<a name="L184"></a><tt class="py-lineno">184</tt>  <tt class="py-line"><tt class="py-string">{{for field in db.table_%(name)s.exposed:}}</tt> </tt>
<a name="L185"></a><tt class="py-lineno">185</tt>  <tt class="py-line"><tt class="py-string">  &lt;tr&gt;</tt> </tt>
<a name="L186"></a><tt class="py-lineno">186</tt>  <tt class="py-line"><tt class="py-string">  &lt;td&gt;{{=db.table_%(name)s.labels[field]}}:&lt;/td&gt;</tt> </tt>
<a name="L187"></a><tt class="py-lineno">187</tt>  <tt class="py-line"><tt class="py-string">  &lt;td&gt;&lt;b&gt;{{=item[field]}}&lt;/b&gt;&lt;/td&gt;</tt> </tt>
<a name="L188"></a><tt class="py-lineno">188</tt>  <tt class="py-line"><tt class="py-string">  &lt;/tr&gt;</tt> </tt>
<a name="L189"></a><tt class="py-lineno">189</tt>  <tt class="py-line"><tt class="py-string">{{pass}}</tt> </tt>
<a name="L190"></a><tt class="py-lineno">190</tt>  <tt class="py-line"><tt class="py-string">&lt;/table&gt;</tt> </tt>
<a name="L191"></a><tt class="py-lineno">191</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L192"></a><tt class="py-lineno">192</tt>  <tt class="py-line"> </tt>
<a name="L193"></a><tt class="py-lineno">193</tt>  <tt class="py-line"><tt id="link-55" class="py-name" targets="Variable gluon.yapo_builder.MAIN_EDIT_VIEW=gluon.yapo_builder-module.html#MAIN_EDIT_VIEW"><a title="gluon.yapo_builder.MAIN_EDIT_VIEW" class="py-name" href="#" onclick="return doclink('link-55', 'MAIN_EDIT_VIEW', 'link-55');">MAIN_EDIT_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""{{extend 'layout.html'}}{{=XML(edit('table_%(name)s',request.args[0]))}}"""</tt> </tt>
<a name="L194"></a><tt class="py-lineno">194</tt>  <tt class="py-line"> </tt>
<a name="L195"></a><tt class="py-lineno">195</tt>  <tt class="py-line"><tt id="link-56" class="py-name" targets="Variable gluon.yapo_builder.CRUD_EDIT_VIEW=gluon.yapo_builder-module.html#CRUD_EDIT_VIEW"><a title="gluon.yapo_builder.CRUD_EDIT_VIEW" class="py-name" href="#" onclick="return doclink('link-56', 'CRUD_EDIT_VIEW', 'link-56');">CRUD_EDIT_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""&lt;h1&gt;Update %(name)s&lt;/h1&gt;{{=form}}"""</tt> </tt>
<a name="L196"></a><tt class="py-lineno">196</tt>  <tt class="py-line"> </tt>
<a name="L197"></a><tt class="py-lineno">197</tt>  <tt class="py-line"><tt id="link-57" class="py-name" targets="Variable gluon.yapo_builder.MAIN_DELETE_VIEW=gluon.yapo_builder-module.html#MAIN_DELETE_VIEW"><a title="gluon.yapo_builder.MAIN_DELETE_VIEW" class="py-name" href="#" onclick="return doclink('link-57', 'MAIN_DELETE_VIEW', 'link-57');">MAIN_DELETE_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""{{extend 'layout.html'}}{{=XML(delete('table_%(name)s',request.args[0]))}}"""</tt> </tt>
<a name="L198"></a><tt class="py-lineno">198</tt>  <tt class="py-line"> </tt>
<a name="L199"></a><tt class="py-lineno">199</tt>  <tt class="py-line"><tt id="link-58" class="py-name" targets="Variable gluon.yapo_builder.CRUD_DELETE_VIEW=gluon.yapo_builder-module.html#CRUD_DELETE_VIEW"><a title="gluon.yapo_builder.CRUD_DELETE_VIEW" class="py-name" href="#" onclick="return doclink('link-58', 'CRUD_DELETE_VIEW', 'link-58');">CRUD_DELETE_VIEW</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L200"></a><tt class="py-lineno">200</tt>  <tt class="py-line"><tt class="py-string">&lt;h1&gt;Delete %(name)s&lt;/h1&gt;</tt> </tt>
<a name="L201"></a><tt class="py-lineno">201</tt>  <tt class="py-line"><tt class="py-string">are you sure you want to delete this record?</tt> </tt>
<a name="L202"></a><tt class="py-lineno">202</tt>  <tt class="py-line"><tt class="py-string">{{=A('yes',_href=URL(r=request,args=request.args,vars=dict(confirm='yes')))}} or</tt> </tt>
<a name="L203"></a><tt class="py-lineno">203</tt>  <tt class="py-line"><tt class="py-string">{{=A('no',_href=URL(r=request,args=request.args,vars=dict(confirm='no')))}}</tt> </tt>
<a name="L204"></a><tt class="py-lineno">204</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L205"></a><tt class="py-lineno">205</tt>  <tt class="py-line"> </tt>
<a name="build_crud"></a><div id="build_crud-def"><a name="L206"></a><tt class="py-lineno">206</tt> <a class="py-toggle" href="#" id="build_crud-toggle" onclick="return toggle('build_crud');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="gluon.yapo_builder-module.html#build_crud">build_crud</a><tt class="py-op">(</tt><tt class="py-param">yapo</tt><tt class="py-op">,</tt><tt class="py-param">path</tt><tt class="py-op">=</tt><tt class="py-string">'./'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="build_crud-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="build_crud-expanded"><a name="L207"></a><tt class="py-lineno">207</tt>  <tt class="py-line">    <tt class="py-name">app_name</tt><tt class="py-op">=</tt><tt id="link-59" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-59', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt> </tt>
<a name="L208"></a><tt class="py-lineno">208</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">=</tt><tt class="py-string">'import os\n\n'</tt> </tt>
<a name="L209"></a><tt class="py-lineno">209</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.title='''%s'''\n"</tt> <tt class="py-op">%</tt> <tt id="link-60" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-60', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">name</tt> <tt class="py-keyword">or</tt> <tt class="py-string">'My Applicaiton'</tt> </tt>
<a name="L210"></a><tt class="py-lineno">210</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.author='''%s'''\n"</tt> <tt class="py-op">%</tt> <tt id="link-61" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-61', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">author</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L211"></a><tt class="py-lineno">211</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.slogan='''%s'''\n"</tt> <tt class="py-op">%</tt> <tt id="link-62" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-62', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">slogan</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L212"></a><tt class="py-lineno">212</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.keywords='''%s'''\n"</tt> <tt class="py-op">%</tt> <tt id="link-63" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-63', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">keywords</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L213"></a><tt class="py-lineno">213</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.description='''%s'''\n"</tt> <tt class="py-op">%</tt> <tt id="link-64" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-64', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">description</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L214"></a><tt class="py-lineno">214</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"response.menu=[%s]\n"</tt> <tt class="py-op">%</tt> <tt class="py-string">''</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-op">[</tt><tt class="py-string">"['%s',False,URL(r=request,f='list_table_%s')],"</tt><tt class="py-op">%</tt><tt class="py-op">(</tt><tt class="py-name">k</tt><tt class="py-op">,</tt><tt class="py-name">k</tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt class="py-name">k</tt> <tt class="py-keyword">in</tt> <tt id="link-65" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-65', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">model</tt><tt class="py-op">.</tt><tt id="link-66" class="py-name"><a title="gluon.yapo.Yapo.keys" class="py-name" href="#" onclick="return doclink('link-66', 'keys', 'link-10');">keys</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">]</tt><tt class="py-op">)</tt>  </tt>
<a name="L215"></a><tt class="py-lineno">215</tt>  <tt class="py-line">    <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">"def download(): response.stream(os.path.join(request.folder,'uploads',request.args[0]))\n\n"</tt> </tt>
<a name="L216"></a><tt class="py-lineno">216</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">exists</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L217"></a><tt class="py-lineno">217</tt>  <tt class="py-line">         <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">mkdir</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L218"></a><tt class="py-lineno">218</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">exists</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L219"></a><tt class="py-lineno">219</tt>  <tt class="py-line">         <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">mkdir</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L220"></a><tt class="py-lineno">220</tt>  <tt class="py-line">    <tt class="py-keyword">for</tt> <tt class="py-name">t</tt> <tt class="py-keyword">in</tt> <tt id="link-67" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-67', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">model</tt><tt class="py-op">.</tt><tt id="link-68" class="py-name"><a title="gluon.yapo.Yapo.keys" class="py-name" href="#" onclick="return doclink('link-68', 'keys', 'link-10');">keys</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L221"></a><tt class="py-lineno">221</tt>  <tt class="py-line">             <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def list_table_%(name)s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L222"></a><tt class="py-lineno">222</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">,</tt><tt class="py-string">'list_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L223"></a><tt class="py-lineno">223</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-69" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-69', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-70" class="py-name"><a title="gluon.yapo_builder.CRUD_LIST_VIEW" class="py-name" href="#" onclick="return doclink('link-70', 'CRUD_LIST_VIEW', 'link-50');">CRUD_LIST_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L224"></a><tt class="py-lineno">224</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'list_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L225"></a><tt class="py-lineno">225</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-71" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-71', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-72" class="py-name"><a title="gluon.yapo_builder.MAIN_LIST_VIEW" class="py-name" href="#" onclick="return doclink('link-72', 'MAIN_LIST_VIEW', 'link-49');">MAIN_LIST_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L226"></a><tt class="py-lineno">226</tt>  <tt class="py-line">             <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def create_table_%(name)s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L227"></a><tt class="py-lineno">227</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">,</tt><tt class="py-string">'create_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L228"></a><tt class="py-lineno">228</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-73" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-73', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-74" class="py-name"><a title="gluon.yapo_builder.CRUD_CREATE_VIEW" class="py-name" href="#" onclick="return doclink('link-74', 'CRUD_CREATE_VIEW', 'link-52');">CRUD_CREATE_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L229"></a><tt class="py-lineno">229</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'create_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L230"></a><tt class="py-lineno">230</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-75" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-75', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-76" class="py-name"><a title="gluon.yapo_builder.MAIN_CREATE_VIEW" class="py-name" href="#" onclick="return doclink('link-76', 'MAIN_CREATE_VIEW', 'link-51');">MAIN_CREATE_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L231"></a><tt class="py-lineno">231</tt>  <tt class="py-line">             <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def read_table_%(name)s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L232"></a><tt class="py-lineno">232</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">,</tt><tt class="py-string">'read_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L233"></a><tt class="py-lineno">233</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-77" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-77', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-78" class="py-name"><a title="gluon.yapo_builder.CRUD_READ_VIEW" class="py-name" href="#" onclick="return doclink('link-78', 'CRUD_READ_VIEW', 'link-54');">CRUD_READ_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L234"></a><tt class="py-lineno">234</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'read_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L235"></a><tt class="py-lineno">235</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-79" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-79', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-80" class="py-name"><a title="gluon.yapo_builder.MAIN_READ_VIEW" class="py-name" href="#" onclick="return doclink('link-80', 'MAIN_READ_VIEW', 'link-53');">MAIN_READ_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L236"></a><tt class="py-lineno">236</tt>  <tt class="py-line">             <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def edit_table_%(name)s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L237"></a><tt class="py-lineno">237</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">,</tt><tt class="py-string">'edit_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L238"></a><tt class="py-lineno">238</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-81" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-81', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-82" class="py-name"><a title="gluon.yapo_builder.CRUD_EDIT_VIEW" class="py-name" href="#" onclick="return doclink('link-82', 'CRUD_EDIT_VIEW', 'link-56');">CRUD_EDIT_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L239"></a><tt class="py-lineno">239</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'edit_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L240"></a><tt class="py-lineno">240</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-83" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-83', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-84" class="py-name"><a title="gluon.yapo_builder.MAIN_EDIT_VIEW" class="py-name" href="#" onclick="return doclink('link-84', 'MAIN_EDIT_VIEW', 'link-55');">MAIN_EDIT_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L241"></a><tt class="py-lineno">241</tt>  <tt class="py-line">             <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def delete_table_%(name)s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt> </tt>
<a name="L242"></a><tt class="py-lineno">242</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'crud'</tt><tt class="py-op">,</tt><tt class="py-string">'delete_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L243"></a><tt class="py-lineno">243</tt>  <tt class="py-line">                 <tt class="py-op">.</tt><tt id="link-85" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-85', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-86" class="py-name"><a title="gluon.yapo_builder.CRUD_DELETE_VIEW" class="py-name" href="#" onclick="return doclink('link-86', 'CRUD_DELETE_VIEW', 'link-58');">CRUD_DELETE_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L244"></a><tt class="py-lineno">244</tt>  <tt class="py-line">             <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'delete_table_%s.html'</tt><tt class="py-op">%</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">,</tt>\ </tt>
<a name="L245"></a><tt class="py-lineno">245</tt>  <tt class="py-line">                 <tt class="py-string">'w'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-87" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-87', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-88" class="py-name"><a title="gluon.yapo_builder.MAIN_DELETE_VIEW" class="py-name" href="#" onclick="return doclink('link-88', 'MAIN_DELETE_VIEW', 'link-57');">MAIN_DELETE_VIEW</a></tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">t</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>          </tt>
<a name="L246"></a><tt class="py-lineno">246</tt>  <tt class="py-line">    <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'controllers'</tt><tt class="py-op">,</tt><tt class="py-string">'main.py'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-89" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-89', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt class="py-name">controller</tt><tt class="py-op">)</tt> </tt>
</div><a name="L247"></a><tt class="py-lineno">247</tt>  <tt class="py-line"> </tt>
<a name="L248"></a><tt class="py-lineno">248</tt>  <tt class="py-line"><tt id="link-90" class="py-name" targets="Variable gluon.yapo_builder.TEST=gluon.yapo_builder-module.html#TEST"><a title="gluon.yapo_builder.TEST" class="py-name" href="#" onclick="return doclink('link-90', 'TEST', 'link-90');">TEST</a></tt><tt class="py-op">=</tt><tt class="py-string">"""</tt> </tt>
<a name="L249"></a><tt class="py-lineno">249</tt>  <tt class="py-line"><tt class="py-string">uri:    sqlite://test.db</tt> </tt>
<a name="L250"></a><tt class="py-lineno">250</tt>  <tt class="py-line"><tt class="py-string">name:   test</tt> </tt>
<a name="L251"></a><tt class="py-lineno">251</tt>  <tt class="py-line"><tt class="py-string">author: Massimo Di Pierro</tt> </tt>
<a name="L252"></a><tt class="py-lineno">252</tt>  <tt class="py-line"><tt class="py-string">model:</tt> </tt>
<a name="L253"></a><tt class="py-lineno">253</tt>  <tt class="py-line"><tt class="py-string">    client:</tt> </tt>
<a name="L254"></a><tt class="py-lineno">254</tt>  <tt class="py-line"><tt class="py-string">        name unique</tt> </tt>
<a name="L255"></a><tt class="py-lineno">255</tt>  <tt class="py-line"><tt class="py-string">        email</tt> </tt>
<a name="L256"></a><tt class="py-lineno">256</tt>  <tt class="py-line"><tt class="py-string">    product:</tt> </tt>
<a name="L257"></a><tt class="py-lineno">257</tt>  <tt class="py-line"><tt class="py-string">        name unique</tt> </tt>
<a name="L258"></a><tt class="py-lineno">258</tt>  <tt class="py-line"><tt class="py-string">        description text</tt> </tt>
<a name="L259"></a><tt class="py-lineno">259</tt>  <tt class="py-line"><tt class="py-string">        image upload</tt> </tt>
<a name="L260"></a><tt class="py-lineno">260</tt>  <tt class="py-line"><tt class="py-string">pages:</tt> </tt>
<a name="L261"></a><tt class="py-lineno">261</tt>  <tt class="py-line"><tt class="py-string">    welcome:</tt> </tt>
<a name="L262"></a><tt class="py-lineno">262</tt>  <tt class="py-line"><tt class="py-string">        content: Test me</tt> </tt>
<a name="L263"></a><tt class="py-lineno">263</tt>  <tt class="py-line"><tt class="py-string">    products:</tt> </tt>
<a name="L264"></a><tt class="py-lineno">264</tt>  <tt class="py-line"><tt class="py-string">        content: Test me</tt> </tt>
<a name="L265"></a><tt class="py-lineno">265</tt>  <tt class="py-line"><tt class="py-string">    about us:</tt> </tt>
<a name="L266"></a><tt class="py-lineno">266</tt>  <tt class="py-line"><tt class="py-string">        content: Test me</tt> </tt>
<a name="L267"></a><tt class="py-lineno">267</tt>  <tt class="py-line"><tt class="py-string">    contact us:</tt> </tt>
<a name="L268"></a><tt class="py-lineno">268</tt>  <tt class="py-line"><tt class="py-string">        content: Test me</tt> </tt>
<a name="L269"></a><tt class="py-lineno">269</tt>  <tt class="py-line"><tt class="py-string">"""</tt> </tt>
<a name="L270"></a><tt class="py-lineno">270</tt>  <tt class="py-line"> </tt>
<a name="build_main"></a><div id="build_main-def"><a name="L271"></a><tt class="py-lineno">271</tt> <a class="py-toggle" href="#" id="build_main-toggle" onclick="return toggle('build_main');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="gluon.yapo_builder-module.html#build_main">build_main</a><tt class="py-op">(</tt><tt class="py-param">yapo</tt><tt class="py-op">,</tt><tt class="py-param">path</tt><tt class="py-op">=</tt><tt class="py-string">'./'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="build_main-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="build_main-expanded"><a name="L272"></a><tt class="py-lineno">272</tt>  <tt class="py-line">    <tt class="py-comment">### FIX THIS!</tt> </tt>
<a name="L273"></a><tt class="py-lineno">273</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-name">controller</tt><tt class="py-op">=</tt><tt class="py-string">'\n'</tt> </tt>
<a name="L274"></a><tt class="py-lineno">274</tt>  <tt class="py-line">    <tt class="py-keyword">for</tt> <tt class="py-name">key</tt><tt class="py-op">,</tt><tt class="py-name">value</tt> <tt class="py-keyword">in</tt> <tt id="link-91" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-91', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">.</tt><tt class="py-name">pages</tt><tt class="py-op">.</tt><tt id="link-92" class="py-name" targets="Method gluon.yapo.Yapo.items()=gluon.yapo.Yapo-class.html#items"><a title="gluon.yapo.Yapo.items" class="py-name" href="#" onclick="return doclink('link-92', 'items', 'link-92');">items</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L275"></a><tt class="py-lineno">275</tt>  <tt class="py-line">        <tt class="py-name">controller</tt><tt class="py-op">+=</tt><tt class="py-string">'def %s(): return dict()\n'</tt> <tt class="py-op">%</tt> <tt class="py-name">key</tt> </tt>
<a name="L276"></a><tt class="py-lineno">276</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">,</tt><tt class="py-name">str</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt id="link-93" class="py-name" targets="Module gluon.html=gluon.html-module.html"><a title="gluon.html" class="py-name" href="#" onclick="return doclink('link-93', 'html', 'link-93');">html</a></tt><tt class="py-op">=</tt><tt class="py-name">value</tt> </tt>
<a name="L277"></a><tt class="py-lineno">277</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt id="link-94" class="py-name"><a title="gluon.html" class="py-name" href="#" onclick="return doclink('link-94', 'html', 'link-93');">html</a></tt><tt class="py-op">=</tt><tt class="py-string">''</tt> </tt>
<a name="L278"></a><tt class="py-lineno">278</tt>  <tt class="py-line">        <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'views'</tt><tt class="py-op">,</tt><tt class="py-string">'main'</tt><tt class="py-op">,</tt><tt class="py-string">'%s.html'</tt> <tt class="py-op">%</tt> <tt class="py-name">key</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'w'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-95" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-95', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt id="link-96" class="py-name"><a title="gluon.html" class="py-name" href="#" onclick="return doclink('link-96', 'html', 'link-93');">html</a></tt><tt class="py-op">)</tt> </tt>
<a name="L279"></a><tt class="py-lineno">279</tt>  <tt class="py-line">    <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'controllers'</tt><tt class="py-op">,</tt><tt class="py-string">'main.py'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'a'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-97" class="py-name"><a title="gluon.globals.Response.write
gluon.widget.IO.write
gluon.wsgiserver.HTTPRequest.write
gluon.wsgiserver.SSLConnection.write
gluon.wsgiserver.SSL_fileobject.write" class="py-name" href="#" onclick="return doclink('link-97', 'write', 'link-6');">write</a></tt><tt class="py-op">(</tt><tt class="py-name">controller</tt><tt class="py-op">)</tt> </tt>
</div><a name="L280"></a><tt class="py-lineno">280</tt>  <tt class="py-line">         </tt>
<a name="L281"></a><tt class="py-lineno">281</tt>  <tt class="py-line"> </tt>
<a name="build_app"></a><div id="build_app-def"><a name="L282"></a><tt class="py-lineno">282</tt> <a class="py-toggle" href="#" id="build_app-toggle" onclick="return toggle('build_app');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="gluon.yapo_builder-module.html#build_app">build_app</a><tt class="py-op">(</tt><tt class="py-param">name</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="build_app-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="build_app-expanded"><a name="L283"></a><tt class="py-lineno">283</tt>  <tt class="py-line">    <tt class="py-docstring">"""</tt> </tt>
<a name="L284"></a><tt class="py-lineno">284</tt>  <tt class="py-line"><tt class="py-docstring">    &gt;&gt; build_app(TEST)</tt> </tt>
<a name="L285"></a><tt class="py-lineno">285</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt>     </tt>
<a name="L286"></a><tt class="py-lineno">286</tt>  <tt class="py-line">    <tt class="py-name">path</tt><tt class="py-op">=</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-string">'applications'</tt><tt class="py-op">,</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L287"></a><tt class="py-lineno">287</tt>  <tt class="py-line">    <tt id="link-98" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-98', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">=</tt><tt id="link-99" class="py-name"><a title="gluon.yapo.Yapo" class="py-name" href="#" onclick="return doclink('link-99', 'Yapo', 'link-1');">Yapo</a></tt><tt class="py-op">(</tt><tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">path</tt><tt class="py-op">,</tt><tt class="py-string">'app.yapo'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt><tt class="py-string">'r'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-100" class="py-name" targets="Method gluon.wsgiserver.SSLConnection.read()=gluon.wsgiserver.SSLConnection-class.html#read,Method gluon.wsgiserver.SSL_fileobject.read()=gluon.wsgiserver.SSL_fileobject-class.html#read,Method gluon.wsgiserver.SizeCheckWrapper.read()=gluon.wsgiserver.SizeCheckWrapper-class.html#read"><a title="gluon.wsgiserver.SSLConnection.read
gluon.wsgiserver.SSL_fileobject.read
gluon.wsgiserver.SizeCheckWrapper.read" class="py-name" href="#" onclick="return doclink('link-100', 'read', 'link-100');">read</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L288"></a><tt class="py-lineno">288</tt>  <tt class="py-line">    <tt id="link-101" class="py-name" targets="Function gluon.yapo_builder.build_model()=gluon.yapo_builder-module.html#build_model"><a title="gluon.yapo_builder.build_model" class="py-name" href="#" onclick="return doclink('link-101', 'build_model', 'link-101');">build_model</a></tt><tt class="py-op">(</tt><tt id="link-102" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-102', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">,</tt><tt class="py-name">path</tt><tt class="py-op">)</tt> </tt>
<a name="L289"></a><tt class="py-lineno">289</tt>  <tt class="py-line">    <tt id="link-103" class="py-name" targets="Function gluon.yapo_builder.build_crud()=gluon.yapo_builder-module.html#build_crud"><a title="gluon.yapo_builder.build_crud" class="py-name" href="#" onclick="return doclink('link-103', 'build_crud', 'link-103');">build_crud</a></tt><tt class="py-op">(</tt><tt id="link-104" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-104', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">,</tt><tt class="py-name">path</tt><tt class="py-op">)</tt> </tt>
<a name="L290"></a><tt class="py-lineno">290</tt>  <tt class="py-line">    <tt id="link-105" class="py-name" targets="Function gluon.yapo_builder.build_main()=gluon.yapo_builder-module.html#build_main"><a title="gluon.yapo_builder.build_main" class="py-name" href="#" onclick="return doclink('link-105', 'build_main', 'link-105');">build_main</a></tt><tt class="py-op">(</tt><tt id="link-106" class="py-name"><a title="gluon.yapo" class="py-name" href="#" onclick="return doclink('link-106', 'yapo', 'link-0');">yapo</a></tt><tt class="py-op">,</tt><tt class="py-name">path</tt><tt class="py-op">)</tt> </tt>
</div><a name="L291"></a><tt class="py-lineno">291</tt>  <tt class="py-line"> </tt>
<a name="L292"></a><tt class="py-lineno">292</tt>  <tt class="py-line"><tt class="py-keyword">if</tt> <tt class="py-name">__name__</tt><tt class="py-op">==</tt><tt class="py-string">'__main__'</tt><tt class="py-op">:</tt> </tt>
<a name="L293"></a><tt class="py-lineno">293</tt>  <tt class="py-line">    <tt class="py-name">name</tt><tt class="py-op">=</tt><tt class="py-name">sys</tt><tt class="py-op">.</tt><tt class="py-name">argv</tt><tt class="py-op">[</tt><tt class="py-number">1</tt><tt class="py-op">]</tt> </tt>
<a name="L294"></a><tt class="py-lineno">294</tt>  <tt class="py-line">    <tt id="link-107" class="py-name" targets="Function gluon.yapo_builder.build_app()=gluon.yapo_builder-module.html#build_app"><a title="gluon.yapo_builder.build_app" class="py-name" href="#" onclick="return doclink('link-107', 'build_app', 'link-107');">build_app</a></tt><tt class="py-op">(</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L295"></a><tt class="py-lineno">295</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0beta1 on Wed Nov 19 14:48:12 2008
    </td>
    <td align="right" class="footer">
      <a target="mainFrame" href="http://epydoc.sourceforge.net"
        >http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie();
  // -->
</script>
</body>
</html>
